﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReportExpiryNumSum.aspx.cs" Inherits="IHISCETeim.Web.MachineSys.FXModel.ReportExpiryNumSum" %>
<%--经销商逾期单数汇总表--%>
 <form id="pagerForm" method="post" action="FXModel/ReportExpiryNumSum.aspx">
 <input type="hidden" name="LeaseCompany" value="<%=LeaseCompany %>" />
 <input type="hidden" name="orderField" value="<%=orderField %>" />
<input type="hidden" name="orderDirection" value="<%=orderDirection %>" />
 </form>
 <form id="ReportExpiryNumSumFrom" runat="server" method="post" action="FXModel/ReportExpiryNumSum.aspx" onsubmit="return navTabSearch(this);">

<div class="pageHeader" style="overflow:hidden!important;">
    <div class="searchBar">
        <table class="searchContent">
            <tr>
                <td>租赁公司：</td>
                <td> <%=GetLeaseCompany("LeaseCompany", LeaseCompany)%></td>
                <td >
                    <div class="subBar">
                        <ul>
                            <li>
                                <div class="buttonActive"><div class="buttonContent"><button type="submit">检索</button></div></div>
                            </li>
                        </ul>
                    </div>
                </td> 
                <td>
                     <div class="subBar">
                        <ul>
                            <li>
                                <div class="buttonActive"><div class="buttonContent"><a href="<%=ExportExcelWebUrl %>/FXModel/ReportExpiryNumSum.aspx?LeaseCompany=<%=HttpUtility.UrlEncode(LeaseCompany) %>" target="_blank" title="确定要导出吗?" style=" line-height:25px!important;" >导出</a></div></div>
                            </li>
                        </ul>
                    </div>
                </td>    
                <td>
                    逾期数据更新时间:<b style="color:red;"><%=IHISCETeim.BLL.FXFinanceLeaseController.GetLastRefresDate()%></b>
                </td>                
            </tr>
        </table>  
    </div>
</div>
<div class="pageContent"> 
    <table class="table" width="1800" layouth="63">
        <thead>
            <tr>
                <th  width="30"></th>
                <th width="100" align="left" <%=GetDataListOrder("经销商") %>>经销商</th>
                <th width="100" align="center" <%=GetDataListOrder("总单数") %>>总单数</th>
                <th width="100" align="center" <%=GetDataListOrder("结清单数") %>>结清单数</th>
                <th width="100" align="center" <%=GetDataListOrder("剩余单数") %>>剩余单数</th>
                <th width="120" align="right" <%=GetDataListOrder("未结清用户月租金") %>>未结清用户月租金</th>
                <th width="100" align="right" <%=GetDataListOrder("剩余总租金") %>>剩余总租金</th>    
                <th width="100" align="center" <%=GetDataListOrder("逾期1期") %>>逾期1期</th>            
                <th width="100" align="center" <%=GetDataListOrder("逾期2期") %>>逾期2期</th> 
                <th width="100" align="center" <%=GetDataListOrder("逾期3期") %>>逾期3期</th>
                <th width="100" align="center" <%=GetDataListOrder("逾期4期") %>>逾期4期</th>
                <th width="100" align="center" <%=GetDataListOrder("逾期5期") %>>逾期5期</th>
                <th width="100" align="center" <%=GetDataListOrder("逾期6期") %>>逾期6期</th>
                <th width="100" align="center" <%=GetDataListOrder("逾期7期") %>>逾期7期</th>
                <th width="100" align="center" <%=GetDataListOrder("逾期8期") %>>逾期>=8期</th>
                <th width="100" align="right" <%=GetDataListOrder("逾期总金额") %>>逾期总金额</th>
                <th width="100">逾期率%</th>
                <th width="100">3期以上单数</th>
                <th width="100" <%=GetDataListOrder("当年合同总数") %>>当年合同总数</th>
                <th width="100" <%=GetDataListOrder("当年剩余总租金") %>>剩余总租金</th>
                <th width="100" <%=GetDataListOrder("当年前6期逾期单数") %>>前6期逾期单数</th>
                <th width="100" <%=GetDataListOrder("当年前6期剩余金额") %>>前6期逾期用户剩余租金</th>
                <th width="100">逾期比率</th>
            </tr>
        </thead>
     <asp:repeater id="rpMenu" runat="server">
        <HeaderTemplate>        
        <tbody>
        </HeaderTemplate>
        <ItemTemplate>
           <tr >
                <td><%=tableRowIndex++ %></td>
                <td ><%# Eval("经销商")%></td>
                <td><%# Eval("总单数")%></td>
                <td><%# Eval("结清单数")%></td>
                <td><%# Eval("剩余单数")%></td>
                <td><%# FormatDecimalToStrings(Eval("未结清用户月租金"), "N")%></td>
                <td><%# FormatDecimalToStrings(Eval("剩余总租金"), "N")%></td>
                <td><%# GetMoneyFormart(Eval("逾期1期"))%></td>
                <td><%# GetMoneyFormart(Eval("逾期2期"))%></td>
                <td><%# GetMoneyFormart(Eval("逾期3期"))%></td>
                <td><%# GetMoneyFormart(Eval("逾期4期"))%></td>
                <td><%# GetMoneyFormart(Eval("逾期5期"))%></td>
                <td><%# GetMoneyFormart(Eval("逾期6期"))%></td>
                <td><%# GetMoneyFormart(Eval("逾期7期"))%></td>
                <td><%# GetMoneyFormart(Eval("逾期8期"))%></td>
                <td><%# FormatDecimalToStrings(Eval("逾期总金额"),"N")%></td>
                <td><%# GetPer(Eval("逾期总金额"),Eval("剩余总租金"))%>%</td>
                <td><%# Convert.ToInt32(Eval("逾期3期")) + Convert.ToInt32(Eval("逾期4期")) + Convert.ToInt32(Eval("逾期5期")) + Convert.ToInt32(Eval("逾期6期")) + Convert.ToInt32(Eval("逾期7期")) + Convert.ToInt32(Eval("逾期8期"))%></td>
			    <td><%# GetMoneyFormart(Eval("当年合同总数"))%></td>
                <td><%# FormatDecimalToStrings(Eval("当年剩余总租金"), "N")%></td>
                <td><%# GetMoneyFormart(Eval("当年前6期逾期单数"))%></td>
                <td><%# FormatDecimalToStrings(Eval("当年前6期剩余金额"), "N")%></td>
                <td><%# GetPer(Eval("当年前6期剩余金额"), Eval("剩余总租金"))%>%</td>
            </tr>
        </ItemTemplate>
        <FooterTemplate>
             <tr class="totalitemtr" >              
                <td colspan="2">合计:</td>
				<td><%# GetSUMDT("总单数")%></td>
                <td><%# GetSUMDT("结清单数")%></td>
                <td><%# GetSUMDT("剩余单数")%></td>
                <td><%# GetSUMDT2("未结清用户月租金")%></td>
                <td><%# GetSUMDT2("剩余总租金")%></td>
                <td><%# GetSUMDT("逾期1期")%></td>
                <td><%# GetSUMDT("逾期2期")%></td>
                <td><%# GetSUMDT("逾期3期")%></td>
                <td><%# GetSUMDT("逾期4期")%></td>
                <td><%# GetSUMDT("逾期5期")%></td>
                <td><%# GetSUMDT("逾期6期")%></td>
                <td><%# GetSUMDT("逾期7期")%></td>
                <td><%# GetSUMDT("逾期8期")%></td>
                <td><%# GetSUMDT2("逾期总金额")%></td>
                <td><%# GetPer(GetSUMDT2("逾期总金额"), GetSUMDT2("剩余总租金"))%>%</td>
                <td><%# GetSUMDT3("逾期3期") + GetSUMDT3("逾期4期") + GetSUMDT3("逾期5期") + GetSUMDT3("逾期6期") + GetSUMDT3("逾期7期") + GetSUMDT3("逾期8期")%></td>
			    <td><%# GetSUMDT2("当年合同总数")%></td>
                <td><%# GetSUMDT2("当年剩余总租金")%></td>
                <td><%# GetSUMDT2("当年前6期逾期单数")%></td>
                <td><%# GetSUMDT2("当年前6期剩余金额")%></td>
                <td><%# GetPer(GetSUMDT2("当年前6期剩余金额"), GetSUMDT2("剩余总租金"))%>%</td>
            </tr>
            </tbody>         
        </FooterTemplate>
    </asp:repeater>
    </table>
</div>

</form>